Database integrity

Database integrity ensures that data entered into the database is accurate, valid, and consistent. Any applicable integrity constraints and data validation rules must be satisfied before permitting a change to the database.

Three basic types of database integrity constraints are:

Entity integrity, not allowing multiple rows to have the same identity within a table.
Domain integrity, restricting data to predefined data types, e.g.: dates.
Referential integrity, requiring the existence of a related row in another table, e.g. a customer for a given customer ID.

Database

Main	Requirements Theory Models Database management system Machine Server Application Connection datasource DSN Administrator Lock Types Tools

Languages	Data definition Data manipulation Query information retrieval

Security	Activity monitoring Audit Forensics Negative database

Design	Entities and relationships Normalization Refactoring

Programming	Abstraction layer Object-relational mapping

Management	Virtualization Tuning caching Migration Preservation Integrity

See also	Database-centric architecture Intelligent Database Two-phase locking Locks with ordered sharing Load file Publishing Halloween Problem Log shipping

Book Category WikiProject

See also